SUPPORT / SAMPLES & SAS NOTES
Problem Note 46986: System Management Facility workload reports with a query filter might result in no output at some customer sites
 |  |  |  |  |
In SAS® IT Resource Management 3.2 and later, some System Management Facility (SMF) reports do not produce output. The problem occurs in workload and logical-partition (LPAR) reports that use the default query filter. The following lists contains the specific reports that might not produce output:.
Workload Reports
- WorkloadTransactionsAndResponseTimeHoursForTheDay
- WorkloadTransactionsAndResponseTimeHoursForLast3Days
- WorkloadTransactionsAndResponseTimeTilesHoursForTheDay
- WorkloadTransactionsAndResponseTimeBarLineHoursForTheDay
- WorkloadTransactionsAndResponseTimeShiftsForTheDay
- WorkloadTransactionsDailyHoursForTheWeek
- WorkloadTransactionsAndResponseTimeTilesDailyHoursForTheWeek
- WorkloadTransactionsAndResponseTimeDailyHoursForTheWeek
- WorkloadTransactionsAndResponseTimeDailyPeakHoursForTheWeek
- WorkloadTransactionResponseTimeDailyHoursForTheWeek
- WorkloadTransactionsAndResponseTimeBLDailyShiftsForTheWeek
- WorkloadTransactionsAndResponseHoursSameDayOfWeekLast4Weeks
- WorkloadTransactionsAndResponseTimeBLDailyShiftsForTheMonth
- WorkloadTransactionResponseTimeDailyHoursForTheMonth
- WorkloadTransactionsAndResponseTimeDailyShiftsForTheMonth
- WorkloadTransactionsAndResponseTimeDailyHoursForTheMonth
- WorkloadTransAndResponseTimeTilesDailyHoursForTheMonth
- WorkloadTransAndResponseTimeDailyPeakHoursForTheMonth
LPAR Reports
- LparStandardEngineCpuHardwareMipsHourlyTrendForLast3Months
- LparStandardEngineCpuHardwareMipsMonthlyForecasting
- LparStandardEngineCpuBusyHourlyTrendForLast3Months
- LparStandardEngineCpuBusyMonthlyForecasting
Workload:
WHERE t1.WorkloadId IN ('BAT', 'OTH2', 'OTH4', 'TSO')
LPAR:
WHERE t1.LparName IN ('DEVA', 'DEVD', 'PROD', 'TST1','VM01')
As a result of the mismatched values, reports are not generated.
To circumvent this problem, update the following SAS® Enterprise Guide® projects so that the filters match a site's workloads or multiple logical partitions (LPARs) definitions:
- IBMSMFRmfLpar.egp
- IBMSMFRMFWorkload.egp
Click the Hot Fix tab in this note to access the hot fix for this issue.
After you install the hot fix, you must follow the steps that are outlined in the section titled "Add, Update, or Delete Report Definitions" of in the SAS® IT Resource Management 3.3: Reporting Guide.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS IT Resource Management-Server | z/OS | 3.2 | 3.4 | 9.2 TS2M3 | 9.4 TS1M0 |
| Microsoft Windows XP Professional | 3.2 | 9.2 TS2M3 | ||||
| Windows 7 Professional 32 bit | 3.2 | 9.2 TS2M3 | ||||
| Windows 7 Home Premium x64 | 3.2 | 9.2 TS2M3 | ||||
| Windows 7 Home Premium 32 bit | 3.2 | 9.2 TS2M3 | ||||
| Windows 7 Enterprise x64 | 3.2 | 3.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 3.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 3.2 | 9.2 TS2M3 | ||||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 3.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 for x64 | 3.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 | 3.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 R2 for x64 | 3.2 | 3.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 3.2 | 3.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Professional x64 | 3.2 | 3.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 3.2 | 9.2 TS2M3 | ||||
| Windows 7 Ultimate x64 | 3.2 | 9.2 TS2M3 | ||||
| Windows Vista | 3.2 | 9.2 TS2M3 | ||||
| Windows Vista for x64 | 3.2 | 9.2 TS2M3 | ||||
| 64-bit Enabled AIX | 3.2 | 3.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| 64-bit Enabled HP-UX | 3.2 | 3.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 3.2 | 3.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| HP-UX IPF | 3.2 | 3.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Linux | 3.2 | 3.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 3.2 | 9.2 TS2M3 | ||||
| Microsoft Windows XP 64-bit Edition | 3.2 | 9.2 TS2M3 | ||||
| Microsoft® Windows® for x64 | 3.2 | 3.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Linux for x64 | 3.2 | 3.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Solaris for x64 | 3.2 | 3.4 | 9.2 TS2M3 | 9.4 TS1M0 | ||